#Country Names + Category
connection = ActiveRecord::Base.connection
connection.execute "DELETE FROM countries;"
connection.execute "INSERT INTO countries (id, name, category) VALUES
  (1, 'Argentina', 1),
  (2, 'Australia', 1),
  (3, 'Austria', 1),
  (4, 'Bahamas', 1),
  (5, 'Bahrain', 1),
  (6, 'Barbados', 1),
  (7, 'Belarus', 1),
  (8, 'Croatia', 1),
  (9, 'Costa Rica', 1),
  (10, 'Chile', 1),
  (11, 'Brunei Darussalam', 1),
  (12, 'Canada', 1),
  (13, 'Bermuda Islands', 1),
  (14, 'Belgium', 1),
  (15, 'France', 1),
  (16, 'Finland', 1),
  (17, 'Estonia', 1),
  (18, 'Denmark', 1),
  (19, 'Czech Republic', 1),
  (20, 'Cyprus', 1),
  (21, 'Cuba', 1),
  (22, 'Hungary', 1),
  (23, 'Hong Kong (China, SAR)', 1),
  (24, 'Germany', 1),
  (25, 'Greece', 1),
  (26, 'Italy', 1),
  (27, 'Israel', 1),
  (28, 'Ireland', 1),
  (29, 'Iceland', 1),
  (30, 'Slovenia', 1),
  (31, 'Slovakia', 1),
  (32, 'Singapore', 1),
  (33, 'Seychelles', 1),
  (34, 'Serbia', 1),
  (35, 'Saint Kitts and Nevis', 1),
  (36, 'Qatar', 1),
  (37, 'Puerto Rico', 1),
  (38, 'Portugal', 1),
  (39, 'Poland', 1),
  (40, 'Norway', 1),
  (41, 'New Zealand', 1),
  (42, 'Netherlands', 1),
  (43, 'Mexico', 1),
  (44, 'Malta', 1),
  (45, 'Luxembourg', 1),
  (46, 'Lithuania', 1),
  (47, 'Korea (Rep. of)', 1),
  (48, 'Latvia', 1),
  (49, 'Kuwait', 1),
  (50, 'Japan', 1),
  (51, 'Uruguay', 1),
  (52, 'United States', 1),
  (53, 'United Kingdom', 1),
  (54, 'United Arab Emirates', 1),
  (55, 'Trinidad and Tobago', 1),
  (56, 'Switzerland', 1),
  (57, 'Sweden', 1),
  (58, 'Spain', 1),
  (59, 'Brazil', 2),
  (60, 'Botswana', 2),
  (61, 'Bosnia and Herzegovina', 2),
  (62, 'Bolivia', 2),
  (63, 'Bhutan', 2),
  (64, 'Belize', 2),
  (65, 'Bangladesh', 2),
  (66, 'Azerbaijan', 2),
  (67, 'Armenia', 2),
  (68, 'Antigua and Barbuda', 2),
  (69, 'Algeria', 2),
  (70, 'Albania', 2),
  (71, 'Dominica', 2),
  (72, 'Congo', 2),
  (73, 'Comoros', 2),
  (74, 'Colombia', 2),
  (75, 'China', 2),
  (76, 'Cape Verde', 2),
  (77, 'Cambodia', 2),
  (78, 'Bulgaria', 2),
  (80, 'Guyana', 2),
  (81, 'Guatemala', 2),
  (82, 'Grenada', 2),
  (83, 'Ghana', 2),
  (84, 'Georgia', 2),
  (85, 'Gabon', 2),
  (86, 'Fiji', 2),
  (87, 'Equatorial Guinea', 2),
  (88, 'El Salvador', 2),
  (89, 'Egypt', 2),
  (90, 'Ecuador', 2),
  (91, 'Dominican Republic', 2),
  (92, 'Malaysia', 2),
  (93, 'Macedonia (TFYR)', 2),
  (94, 'Libyan Arab Jamahiriya', 2),
  (95, 'Lesotho', 2),
  (96, 'Lebanon', 2),
  (97, 'Lao Peoples Dem. Rep.', 2),
  (98, 'Kyrgyzstan', 2),
  (99, 'Kazakhstan', 2),
  (100, 'Jordan', 2),
  (101, 'Jamaica', 2),
  (102, 'Iran (Islamic Rep. of)', 2),
  (103, 'Indonesia', 2),
  (104, 'India', 2),
  (105, 'Honduras', 2),
  (106, 'Sao Tome and Principe', 2),
  (107, 'Samoa (Western)', 2),
  (108, 'St. Vincent and the Grenadines', 2),
  (109, 'Saint Lucia', 2),
  (110, 'Russian Federation', 2),
  (111, 'Romania', 2),
  (112, 'Philippines', 2),
  (113, 'Peru', 2),
  (114, 'Paraguay', 2),
  (115, 'Papua New Guinea', 2),
  (116, 'Panama', 2),
  (117, 'Oman', 2),
  (118, 'Occupied Palestinian Territories', 2),
  (119, 'Nicaragua', 2),
  (120, 'Namibia', 2),
  (121, 'Myanmar', 2),
  (122, 'Morocco', 2),
  (123, 'Mongolia', 2),
  (124, 'Moldova (Rep. of)', 2),
  (125, 'Mauritius', 2),
  (126, 'Maldives', 2),
  (127, 'Viet Nam', 2),
  (128, 'Venezuela', 2),
  (129, 'Vanuatu', 2),
  (130, 'Uzbekistan', 2),
  (131, 'Ukraine', 2),
  (132, 'Turkmenistan', 2),
  (133, 'Turkey', 2),
  (134, 'Tunisia', 2),
  (135, 'Togo', 2),
  (136, 'Thailand', 2),
  (137, 'Tajikistan', 2),
  (138, 'Taiwan', 2),
  (139, 'Syrian Arab Republic', 2),
  (140, 'Swaziland', 2),
  (141, 'Suriname', 2),
  (142, 'Sudan', 2),
  (143, 'Sri Lanka', 2),
  (144, 'South Africa', 2),
  (145, 'Solomon Islands', 2),
  (146, 'Saudi Arabia', 2),
  (147, 'Cote d Ivoire', 3),
  (148, 'Congo (Dem. Rep. of the)', 3),
  (149, 'Chad', 3),
  (150, 'Central African Republic', 3),
  (151, 'Cameroon', 3),
  (152, 'Burundi', 3),
  (153, 'Burkina Faso', 3),
  (154, 'Benin', 3),
  (155, 'Angola', 3),
  (156, 'Zimbabwe', 3),
  (157, 'Zambia', 3),
  (158, 'Yemen', 3),
  (159, 'Uganda', 3),
  (160, 'Tanzania (U. Rep. of)', 3),
  (161, 'Sierra Leone', 3),
  (162, 'Senegal', 3),
  (163, 'Rwanda', 3),
  (164, 'Pakistan', 3),
  (165, 'Nigeria', 3),
  (166, 'Niger', 3),
  (167, 'Nepal', 3),
  (168, 'Mozambique', 3),
  (169, 'Mauritania', 3),
  (170, 'Mali', 3),
  (171, 'Malawi', 3),
  (172, 'Madagascar', 3),
  (173, 'Liberia', 3),
  (174, 'Kenya', 3),
  (175, 'Haiti', 3),
  (176, 'Guinea-Bissau', 3),
  (177, 'Guinea', 3),
  (178, 'Gambia', 3),
  (179, 'Ethiopia', 3),
  (180, 'Eritrea', 3),
  (181, 'Djibouti', 3);"
